Overview

Dataset statistics

Number of variables30
Number of observations2260701
Missing cells4735231
Missing cells (%)7.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.8 GiB
Average record size in memory1.3 KiB

Variable types

CAT16
NUM11
URL1
BOOL1
UNSUPPORTED1

Reproduction

Analysis started2020-10-29 15:36:03.361973
Analysis finished2020-10-29 15:53:58.508170
Versionpandas-profiling v2.6.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml
id has a high cardinality: 2260701 distinct values High cardinality
emp_title has a high cardinality: 512694 distinct values High cardinality
issue_d has a high cardinality: 139 distinct values High cardinality
desc has a high cardinality: 124501 distinct values High cardinality
title has a high cardinality: 63155 distinct values High cardinality
zip_code has a high cardinality: 956 distinct values High cardinality
addr_state has a high cardinality: 51 distinct values High cardinality
earliest_cr_line has a high cardinality: 754 distinct values High cardinality
funded_amnt is highly correlated with loan_amnt and 2 other fieldsHigh Correlation
loan_amnt is highly correlated with funded_amnt and 2 other fieldsHigh Correlation
funded_amnt_inv is highly correlated with loan_amnt and 2 other fieldsHigh Correlation
installment is highly correlated with loan_amnt and 2 other fieldsHigh Correlation
fico_range_high is highly correlated with fico_range_lowHigh Correlation
fico_range_low is highly correlated with fico_range_highHigh Correlation
sub_grade is highly correlated with gradeHigh Correlation
grade is highly correlated with sub_gradeHigh Correlation
member_id has 2260701 (100.0%) missing values Missing
emp_title has 167002 (7.4%) missing values Missing
emp_length has 146940 (6.5%) missing values Missing
desc has 2134634 (94.4%) missing values Missing
title has 23358 (1.0%) missing values Missing
annual_inc is highly skewed (γ1 = 493.8860884) Skewed
dti is highly skewed (γ1 = 29.20185447) Skewed
member_id is an unsupported type, check if it needs cleaning or further analysis Rejected
delinq_2yrs has 1839108 (81.4%) zeros Zeros
inq_last_6mths has 1381722 (61.1%) zeros Zeros

Variables

id
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE
Distinct count2260701
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size17.2 MiB
1706248
 
1
136433415
 
1
18204415
 
1
69752402
 
1
139649583
 
1
Other values (2260696)
2260696
ValueCountFrequency (%) 
1706248 1 < 0.1%
 
136433415 1 < 0.1%
 
18204415 1 < 0.1%
 
69752402 1 < 0.1%
 
139649583 1 < 0.1%
 
141412540 1 < 0.1%
 
84404486 1 < 0.1%
 
84594351 1 < 0.1%
 
95209919 1 < 0.1%
 
74626314 1 < 0.1%
 
Other values (2260691) 2260691 > 99.9%
 

Length

Max length48
Mean length8.265717138
Min length5
ValueCountFrequency (%) 
Lowercase_Letter 17 54.8%
 
Decimal_Number 10 32.3%
 
Uppercase_Letter 2 6.5%
 
Space_Separator 1 3.2%
 
Other_Punctuation 1 3.2%
 
ValueCountFrequency (%) 
Latin 19 61.3%
 
Common 12 38.7%
 
ValueCountFrequency (%) 
ASCII 31 100.0%
 

member_id
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing2260701
Missing (%)100.0%
Memory size17.2 MiB

loan_amnt
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count1572
Unique (%)0.1%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean15046.93123
Minimum500
Maximum40000
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum500
5-th percentile3250
Q18000
median12900
Q320000
95-th percentile35000
Maximum40000
Range39500
Interquartile range (IQR)12000

Descriptive statistics

Standard deviation9190.245488
Coefficient of variation (CV)0.6107720803
Kurtosis-0.1194391577
Mean15046.93123
Median Absolute Deviation (MAD)7445.307472
Skewness0.7777823287
Sum3.401611592e+10
Variance84460612.13
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10000 187236 8.3%
 
20000 131006 5.8%
 
15000 123226 5.5%
 
12000 121681 5.4%
 
35000 86285 3.8%
 
5000 84765 3.7%
 
8000 75033 3.3%
 
6000 72089 3.2%
 
25000 66453 2.9%
 
16000 66418 2.9%
 
Other values (1562) 1246476 55.1%
 
ValueCountFrequency (%) 
500 11 < 0.1%
 
550 1 < 0.1%
 
600 6 < 0.1%
 
700 3 < 0.1%
 
725 1 < 0.1%
 
ValueCountFrequency (%) 
40000 33368 1.5%
 
39975 11 < 0.1%
 
39950 10 < 0.1%
 
39925 14 < 0.1%
 
39900 24 < 0.1%
 

funded_amnt
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count1572
Unique (%)0.1%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean15041.66406
Minimum500
Maximum40000
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum500
5-th percentile3250
Q18000
median12875
Q320000
95-th percentile35000
Maximum40000
Range39500
Interquartile range (IQR)12000

Descriptive statistics

Standard deviation9188.413022
Coefficient of variation (CV)0.6108641296
Kurtosis-0.1170090387
Mean15041.66406
Median Absolute Deviation (MAD)7442.540455
Skewness0.7787785936
Sum3.40042086e+10
Variance84426933.87
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10000 187146 8.3%
 
20000 130816 5.8%
 
15000 123110 5.4%
 
12000 121588 5.4%
 
35000 86147 3.8%
 
5000 84751 3.7%
 
8000 75020 3.3%
 
6000 72075 3.2%
 
16000 66331 2.9%
 
25000 66176 2.9%
 
Other values (1562) 1247508 55.2%
 
ValueCountFrequency (%) 
500 11 < 0.1%
 
550 1 < 0.1%
 
600 6 < 0.1%
 
700 3 < 0.1%
 
725 1 < 0.1%
 
ValueCountFrequency (%) 
40000 33368 1.5%
 
39975 11 < 0.1%
 
39950 10 < 0.1%
 
39925 14 < 0.1%
 
39900 24 < 0.1%
 

funded_amnt_inv
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count10057
Unique (%)0.4%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean15023.43775
Minimum0
Maximum40000
Zeros233
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile3200
Q18000
median12800
Q320000
95-th percentile35000
Maximum40000
Range40000
Interquartile range (IQR)12000

Descriptive statistics

Standard deviation9192.331679
Coefficient of variation (CV)0.6118660612
Kurtosis-0.1166814573
Mean15023.43775
Median Absolute Deviation (MAD)7444.677901
Skewness0.7782542751
Sum3.396300496e+10
Variance84498961.69
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10000 177561 7.9%
 
20000 120453 5.3%
 
15000 114539 5.1%
 
12000 114068 5.0%
 
5000 81999 3.6%
 
35000 76093 3.4%
 
8000 71528 3.2%
 
6000 69475 3.1%
 
16000 61840 2.7%
 
25000 60610 2.7%
 
Other values (10047) 1312502 58.1%
 
ValueCountFrequency (%) 
0 233 < 0.1%
 
0.000121098108 1 < 0.1%
 
0.000185369401 1 < 0.1%
 
0.000242055511 1 < 0.1%
 
0.000531133069 1 < 0.1%
 
ValueCountFrequency (%) 
40000 31767 1.4%
 
39975 616 < 0.1%
 
39950 218 < 0.1%
 
39925 58 < 0.1%
 
39900 29 < 0.1%
 

term
Categorical

Distinct count2
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
36 months
1609754
60 months
650914
ValueCountFrequency (%) 
36 months 1609754 71.2%
 
60 months 650914 28.8%
 
(Missing) 33 < 0.1%
 

Length

Max length10
Mean length9.999897819
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 7 63.6%
 
Decimal_Number 3 27.3%
 
Space_Separator 1 9.1%
 
ValueCountFrequency (%) 
Latin 7 63.6%
 
Common 4 36.4%
 
ValueCountFrequency (%) 
ASCII 11 100.0%
 

int_rate
Real number (ℝ≥0)

Distinct count673
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean13.09282911
Minimum5.31
Maximum30.99
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum5.31
5-th percentile6.49
Q19.49
median12.62
Q315.99
95-th percentile22.15
Maximum30.99
Range25.68
Interquartile range (IQR)6.5

Descriptive statistics

Standard deviation4.832138365
Coefficient of variation (CV)0.36906755
Kurtosis0.5940245697
Mean13.09282911
Median Absolute Deviation (MAD)3.799125792
Skewness0.7680705625
Sum29598539.81
Variance23.34956117
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
11.99 53869 2.4%
 
5.32 47171 2.1%
 
10.99 44165 2.0%
 
13.99 43025 1.9%
 
11.49 32010 1.4%
 
16.99 30564 1.4%
 
12.99 29276 1.3%
 
7.89 28514 1.3%
 
9.17 27835 1.2%
 
15.61 25208 1.1%
 
Other values (663) 1899031 84.0%
 
ValueCountFrequency (%) 
5.31 8613 0.4%
 
5.32 47171 2.1%
 
5.42 573 < 0.1%
 
5.79 410 < 0.1%
 
5.93 1812 0.1%
 
ValueCountFrequency (%) 
30.99 819 < 0.1%
 
30.94 733 < 0.1%
 
30.89 699 < 0.1%
 
30.84 755 < 0.1%
 
30.79 1572 0.1%
 

installment
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count93301
Unique (%)4.1%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean445.8068229
Minimum4.93
Maximum1719.83
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum4.93
5-th percentile110.43
Q1251.65
median377.99
Q3593.32
95-th percentile984.47
Maximum1719.83
Range1714.9
Interquartile range (IQR)341.67

Descriptive statistics

Standard deviation267.1735346
Coefficient of variation (CV)0.5993033774
Kurtosis0.6898790426
Mean445.8068229
Median Absolute Deviation (MAD)211.60717
Skewness1.001780569
Sum1007821219
Variance71381.6976
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
301.15 4420 0.2%
 
332.1 4153 0.2%
 
361.38 3704 0.2%
 
327.34 3353 0.1%
 
602.3 3095 0.1%
 
451.73 3076 0.1%
 
329.72 2614 0.1%
 
166.05 2508 0.1%
 
498.15 2410 0.1%
 
180.69 2364 0.1%
 
Other values (93291) 2228971 98.6%
 
ValueCountFrequency (%) 
4.93 1 < 0.1%
 
7.61 1 < 0.1%
 
14.01 1 < 0.1%
 
14.77 1 < 0.1%
 
15.67 1 < 0.1%
 
ValueCountFrequency (%) 
1719.83 2 < 0.1%
 
1717.63 1 < 0.1%
 
1715.42 2 < 0.1%
 
1714.54 6 < 0.1%
 
1691.28 2 < 0.1%
 

grade
Categorical

HIGH CORRELATION
Distinct count7
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
B
663557
C
650053
A
433027
D
324424
E
135639
Other values (2)
 
53968
ValueCountFrequency (%) 
B 663557 29.4%
 
C 650053 28.8%
 
A 433027 19.2%
 
D 324424 14.4%
 
E 135639 6.0%
 
F 41800 1.8%
 
G 12168 0.5%
 
(Missing) 33 < 0.1%
 

Length

Max length3
Mean length1.000029194
Min length1
ValueCountFrequency (%) 
Uppercase_Letter 7 77.8%
 
Lowercase_Letter 2 22.2%
 
ValueCountFrequency (%) 
Latin 9 100.0%
 
ValueCountFrequency (%) 
ASCII 9 100.0%
 

sub_grade
Categorical

HIGH CORRELATION
Distinct count35
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
C1
 
145903
B5
 
140288
B4
 
139793
B3
 
131514
C2
 
131116
Other values (30)
1572054
ValueCountFrequency (%) 
C1 145903 6.5%
 
B5 140288 6.2%
 
B4 139793 6.2%
 
B3 131514 5.8%
 
C2 131116 5.8%
 
C3 129193 5.7%
 
C4 127115 5.6%
 
B2 126621 5.6%
 
B1 125341 5.5%
 
C5 116726 5.2%
 
Other values (25) 947058 41.9%
 

Length

Max length3
Mean length2.000014597
Min length2
ValueCountFrequency (%) 
Uppercase_Letter 7 50.0%
 
Decimal_Number 5 35.7%
 
Lowercase_Letter 2 14.3%
 
ValueCountFrequency (%) 
Latin 9 64.3%
 
Common 5 35.7%
 
ValueCountFrequency (%) 
ASCII 14 100.0%
 

emp_title
Categorical

HIGH CARDINALITY
MISSING
Distinct count512694
Unique (%)24.5%
Missing167002
Missing (%)7.4%
Memory size17.2 MiB
Teacher
 
38824
Manager
 
34298
Owner
 
21977
Registered Nurse
 
15867
Driver
 
14753
Other values (512689)
1967980
ValueCountFrequency (%) 
Teacher 38824 1.7%
 
Manager 34298 1.5%
 
Owner 21977 1.0%
 
Registered Nurse 15867 0.7%
 
Driver 14753 0.7%
 
RN 14737 0.7%
 
Supervisor 14297 0.6%
 
Sales 13050 0.6%
 
Project Manager 10971 0.5%
 
Office Manager 9772 0.4%
 
Other values (512684) 1905153 84.3%
 
(Missing) 167002 7.4%
 

Length

Max length78
Mean length14.66562938
Min length1
ValueCountFrequency (%) 
Lowercase_Letter 53 31.2%
 
Uppercase_Letter 35 20.6%
 
Other_Punctuation 18 10.6%
 
Control 13 7.6%
 
Decimal_Number 10 5.9%
 
Math_Symbol 7 4.1%
 
Other_Symbol 5 2.9%
 
Format 4 2.4%
 
Modifier_Symbol 3 1.8%
 
Dash_Punctuation 3 1.8%
 
Other values (9) 19 11.2%
 
ValueCountFrequency (%) 
Common 81 47.6%
 
Latin 76 44.7%
 
Cyrillic 6 3.5%
 
Armenian 3 1.8%
 
Inherited 2 1.2%
 
Greek 2 1.2%
 
ValueCountFrequency (%) 
ASCII 94 79.7%
 
Punctuation 9 7.6%
 
Cyrillic 6 5.1%
 
Armenian 3 2.5%
 
IPA Ext 2 1.7%
 
Letterlike Symbols 1 0.8%
 
Math Operators 1 0.8%
 
Misc Symbols 1 0.8%
 
VS 1 0.8%
 

emp_length
Categorical

MISSING
Distinct count11
Unique (%)< 0.1%
Missing146940
Missing (%)6.5%
Memory size17.2 MiB
10+ years
748005
2 years
203677
< 1 year
189988
3 years
180753
1 year
 
148403
Other values (6)
642935
ValueCountFrequency (%) 
10+ years 748005 33.1%
 
2 years 203677 9.0%
 
< 1 year 189988 8.4%
 
3 years 180753 8.0%
 
1 year 148403 6.6%
 
5 years 139698 6.2%
 
4 years 136605 6.0%
 
6 years 102628 4.5%
 
7 years 92695 4.1%
 
8 years 91914 4.1%
 
(Missing) 146940 6.5%
 

Length

Max length9
Mean length7.420150652
Min length3
ValueCountFrequency (%) 
Decimal_Number 10 52.6%
 
Lowercase_Letter 6 31.6%
 
Math_Symbol 2 10.5%
 
Space_Separator 1 5.3%
 
ValueCountFrequency (%) 
Common 13 68.4%
 
Latin 6 31.6%
 
ValueCountFrequency (%) 
ASCII 19 100.0%
 

home_ownership
Categorical

Distinct count6
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
MORTGAGE
1111450
RENT
894929
OWN
253057
ANY
 
996
OTHER
 
182
ValueCountFrequency (%) 
MORTGAGE 1111450 49.2%
 
RENT 894929 39.6%
 
OWN 253057 11.2%
 
ANY 996 < 0.1%
 
OTHER 182 < 0.1%
 
NONE 54 < 0.1%
 
(Missing) 33 < 0.1%
 

Length

Max length8
Mean length5.854246094
Min length3
ValueCountFrequency (%) 
Uppercase_Letter 11 84.6%
 
Lowercase_Letter 2 15.4%
 
ValueCountFrequency (%) 
Latin 13 100.0%
 
ValueCountFrequency (%) 
ASCII 13 100.0%
 

annual_inc
Real number (ℝ≥0)

SKEWED
Distinct count89368
Unique (%)4.0%
Missing37
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean77992.42869
Minimum0
Maximum110000000
Zeros1667
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile27600
Q146000
median65000
Q393000
95-th percentile160000
Maximum110000000
Range110000000
Interquartile range (IQR)47000

Descriptive statistics

Standard deviation112696.1996
Coefficient of variation (CV)1.444963331
Kurtosis439001.6589
Mean77992.42869
Median Absolute Deviation (MAD)34549.45122
Skewness493.8860884
Sum1.763146758e+11
Variance1.27004334e+10
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
60000 87189 3.9%
 
50000 76355 3.4%
 
65000 64903 2.9%
 
70000 62078 2.7%
 
80000 59833 2.6%
 
40000 59684 2.6%
 
75000 58459 2.6%
 
45000 54534 2.4%
 
55000 51583 2.3%
 
100000 46977 2.1%
 
Other values (89358) 1639069 72.5%
 
ValueCountFrequency (%) 
0 1667 0.1%
 
0.36 1 < 0.1%
 
1 42 < 0.1%
 
2 1 < 0.1%
 
3 1 < 0.1%
 
ValueCountFrequency (%) 
110000000 1 < 0.1%
 
61000000 1 < 0.1%
 
10999200 1 < 0.1%
 
9930475 1 < 0.1%
 
9757200 1 < 0.1%
 
Distinct count3
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
Source Verified
886231
Not Verified
744806
Verified
629631
ValueCountFrequency (%) 
Source Verified 886231 39.2%
 
Not Verified 744806 32.9%
 
Verified 629631 27.9%
 
(Missing) 33 < 0.1%
 

Length

Max length15
Mean length12.06187107
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 11 73.3%
 
Uppercase_Letter 3 20.0%
 
Space_Separator 1 6.7%
 
ValueCountFrequency (%) 
Latin 14 93.3%
 
Common 1 6.7%
 
ValueCountFrequency (%) 
ASCII 15 100.0%
 

issue_d
Categorical

HIGH CARDINALITY
Distinct count139
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
Mar-2016
 
61992
Oct-2015
 
48631
May-2018
 
46311
Oct-2018
 
46305
Aug-2018
 
46079
Other values (134)
2011350
ValueCountFrequency (%) 
Mar-2016 61992 2.7%
 
Oct-2015 48631 2.2%
 
May-2018 46311 2.0%
 
Oct-2018 46305 2.0%
 
Aug-2018 46079 2.0%
 
Jul-2015 45962 2.0%
 
Dec-2015 44343 2.0%
 
Aug-2017 43573 1.9%
 
Jul-2018 43089 1.9%
 
Apr-2018 42928 1.9%
 
Other values (129) 1791455 79.2%
 

Length

Max length8
Mean length7.999927014
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 14 42.4%
 
Decimal_Number 10 30.3%
 
Uppercase_Letter 8 24.2%
 
Dash_Punctuation 1 3.0%
 
ValueCountFrequency (%) 
Latin 22 66.7%
 
Common 11 33.3%
 
ValueCountFrequency (%) 
ASCII 33 100.0%
 

loan_status
Categorical

Distinct count9
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
Fully Paid
1076751
Current
878317
Charged Off
268559
Late (31-120 days)
 
21467
In Grace Period
 
8436
Other values (4)
 
7138
ValueCountFrequency (%) 
Fully Paid 1076751 47.6%
 
Current 878317 38.9%
 
Charged Off 268559 11.9%
 
Late (31-120 days) 21467 0.9%
 
In Grace Period 8436 0.4%
 
Late (16-30 days) 4349 0.2%
 
Does not meet the credit policy. Status:Fully Paid 1988 0.1%
 
Does not meet the credit policy. Status:Charged Off 761 < 0.1%
 
Default 40 < 0.1%
 
(Missing) 33 < 0.1%
 

Length

Max length51
Mean length9.110159636
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 18 47.4%
 
Uppercase_Letter 9 23.7%
 
Decimal_Number 5 13.2%
 
Other_Punctuation 2 5.3%
 
Dash_Punctuation 1 2.6%
 
Open_Punctuation 1 2.6%
 
Space_Separator 1 2.6%
 
Close_Punctuation 1 2.6%
 
ValueCountFrequency (%) 
Latin 27 71.1%
 
Common 11 28.9%
 
ValueCountFrequency (%) 
ASCII 38 100.0%
 

pymnt_plan
Boolean

Distinct count2
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
n
2260048
y
 
620
(Missing)
 
33
ValueCountFrequency (%) 
n 2260048 > 99.9%
 
y 620 < 0.1%
 
(Missing) 33 < 0.1%
 

url
URL

Distinct count2260668
Unique (%)100.0%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
https://lendingclub.com/browse/loanDetail.action?loan_id=38635095
 
1
https://lendingclub.com/browse/loanDetail.action?loan_id=91041952
 
1
https://lendingclub.com/browse/loanDetail.action?loan_id=136220591
 
1
https://lendingclub.com/browse/loanDetail.action?loan_id=51877925
 
1
https://lendingclub.com/browse/loanDetail.action?loan_id=126099280
 
1
Other values (2260663)
2260663
(Missing)
 
33
ValueCountFrequency (%) 
https://lendingclub.com/browse/loanDetail.action?loan_id=38635095 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=91041952 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=136220591 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=51877925 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=126099280 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=143652747 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=68577858 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=11686311 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=26760102 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=136103905 1 < 0.1%
 
Other values (2260658) 2260658 > 99.9%
 
(Missing) 33 < 0.1%
 
ValueCountFrequency (%) 
https 2260668 > 99.9%
 
(Missing) 33 < 0.1%
 
ValueCountFrequency (%) 
lendingclub.com 2260668 > 99.9%
 
(Missing) 33 < 0.1%
 
ValueCountFrequency (%) 
/browse/loanDetail.action 2260668 > 99.9%
 
(Missing) 33 < 0.1%
 
ValueCountFrequency (%) 
loan_id=70553619 1 < 0.1%
 
loan_id=141192501 1 < 0.1%
 
loan_id=26329678 1 < 0.1%
 
loan_id=19687013 1 < 0.1%
 
loan_id=104201158 1 < 0.1%
 
loan_id=72226814 1 < 0.1%
 
loan_id=445130 1 < 0.1%
 
loan_id=3707004 1 < 0.1%
 
loan_id=15350226 1 < 0.1%
 
loan_id=90087750 1 < 0.1%
 
Other values (2260658) 2260658 > 99.9%
 
(Missing) 33 < 0.1%
 
ValueCountFrequency (%) 
2260668 > 99.9%
 
(Missing) 33 < 0.1%
 

desc
Categorical

HIGH CARDINALITY
MISSING
UNIFORM
Distinct count124501
Unique (%)98.8%
Missing2134634
Missing (%)94.4%
Memory size17.2 MiB
 
252
Debt Consolidation
 
13
Borrower added on 03/17/14 > Debt consolidation<br>
 
11
Borrower added on 03/10/14 > Debt consolidation<br>
 
10
Borrower added on 02/19/14 > Debt consolidation<br>
 
9
Other values (124496)
125772
ValueCountFrequency (%) 
252 < 0.1%
 
Debt Consolidation 13 < 0.1%
 
Borrower added on 03/17/14 > Debt consolidation<br> 11 < 0.1%
 
Borrower added on 03/10/14 > Debt consolidation<br> 10 < 0.1%
 
Borrower added on 02/19/14 > Debt consolidation<br> 9 < 0.1%
 
Borrower added on 01/29/14 > Debt consolidation<br> 8 < 0.1%
 
Camping Membership 8 < 0.1%
 
Borrower added on 01/15/14 > Debt consolidation<br> 7 < 0.1%
 
Borrower added on 01/22/14 > Debt consolidation<br> 7 < 0.1%
 
Borrower added on 02/26/14 > Debt Consolidation<br> 6 < 0.1%
 
Other values (124491) 125736 5.6%
 
(Missing) 2134634 94.4%
 

Length

Max length3988
Mean length16.21424859
Min length1
ValueCountFrequency (%) 
Uppercase_Letter 31 21.8%
 
Lowercase_Letter 28 19.7%
 
Other_Punctuation 20 14.1%
 
Control 19 13.4%
 
Decimal_Number 10 7.0%
 
Math_Symbol 7 4.9%
 
Other_Symbol 4 2.8%
 
Modifier_Symbol 3 2.1%
 
Dash_Punctuation 3 2.1%
 
Open_Punctuation 3 2.1%
 
Other values (7) 14 9.9%
 
ValueCountFrequency (%) 
Common 83 58.5%
 
Latin 59 41.5%
 
ValueCountFrequency (%) 
ASCII 96 91.4%
 
Punctuation 8 7.6%
 
Specials 1 1.0%
 

purpose
Categorical

Distinct count14
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
debt_consolidation
1277877
credit_card
516971
home_improvement
 
150457
other
 
139440
major_purchase
 
50445
Other values (9)
 
125478
ValueCountFrequency (%) 
debt_consolidation 1277877 56.5%
 
credit_card 516971 22.9%
 
home_improvement 150457 6.7%
 
other 139440 6.2%
 
major_purchase 50445 2.2%
 
medical 27488 1.2%
 
small_business 24689 1.1%
 
car 24013 1.1%
 
vacation 15525 0.7%
 
moving 15403 0.7%
 
Other values (4) 18360 0.8%
 

Length

Max length18
Mean length14.7923038
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 21 95.5%
 
Connector_Punctuation 1 4.5%
 
ValueCountFrequency (%) 
Latin 21 95.5%
 
Common 1 4.5%
 
ValueCountFrequency (%) 
ASCII 22 100.0%
 

title
Categorical

HIGH CARDINALITY
MISSING
Distinct count63155
Unique (%)2.8%
Missing23358
Missing (%)1.0%
Memory size17.2 MiB
Debt consolidation
1153293
Credit card refinancing
469691
Home improvement
 
137437
Other
 
127714
Major purchase
 
44840
Other values (63150)
304368
ValueCountFrequency (%) 
Debt consolidation 1153293 51.0%
 
Credit card refinancing 469691 20.8%
 
Home improvement 137437 6.1%
 
Other 127714 5.6%
 
Major purchase 44840 2.0%
 
Medical expenses 25388 1.1%
 
Business 20804 0.9%
 
Car financing 20526 0.9%
 
Debt Consolidation 15763 0.7%
 
Vacation 14443 0.6%
 
Other values (63145) 207444 9.2%
 
(Missing) 23358 1.0%
 

Length

Max length80
Mean length17.53985998
Min length2
ValueCountFrequency (%) 
Uppercase_Letter 28 25.9%
 
Lowercase_Letter 28 25.9%
 
Other_Punctuation 15 13.9%
 
Decimal_Number 10 9.3%
 
Control 8 7.4%
 
Math_Symbol 6 5.6%
 
Modifier_Symbol 3 2.8%
 
Close_Punctuation 2 1.9%
 
Open_Punctuation 2 1.9%
 
Other_Symbol 1 0.9%
 
Other values (5) 5 4.6%
 
ValueCountFrequency (%) 
Latin 56 51.9%
 
Common 52 48.1%
 
ValueCountFrequency (%) 
ASCII 94 100.0%
 

zip_code
Categorical

HIGH CARDINALITY
Distinct count956
Unique (%)< 0.1%
Missing34
Missing (%)< 0.1%
Memory size17.2 MiB
112xx
 
23908
945xx
 
23782
750xx
 
23649
606xx
 
21192
300xx
 
20497
Other values (951)
2147639
ValueCountFrequency (%) 
112xx 23908 1.1%
 
945xx 23782 1.1%
 
750xx 23649 1.0%
 
606xx 21192 0.9%
 
300xx 20497 0.9%
 
331xx 19051 0.8%
 
070xx 18316 0.8%
 
770xx 17719 0.8%
 
891xx 17162 0.8%
 
100xx 17103 0.8%
 
Other values (946) 2058288 91.0%
 

Length

Max length5
Mean length4.999969921
Min length3
ValueCountFrequency (%) 
Decimal_Number 10 76.9%
 
Lowercase_Letter 3 23.1%
 
ValueCountFrequency (%) 
Common 10 76.9%
 
Latin 3 23.1%
 
ValueCountFrequency (%) 
ASCII 13 100.0%
 

addr_state
Categorical

HIGH CARDINALITY
Distinct count51
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
CA
314533
NY
 
186389
TX
 
186335
FL
 
161991
IL
 
91173
Other values (46)
1320247
ValueCountFrequency (%) 
CA 314533 13.9%
 
NY 186389 8.2%
 
TX 186335 8.2%
 
FL 161991 7.2%
 
IL 91173 4.0%
 
NJ 83132 3.7%
 
PA 76939 3.4%
 
OH 75132 3.3%
 
GA 74196 3.3%
 
VA 62954 2.8%
 
Other values (41) 947894 41.9%
 

Length

Max length3
Mean length2.000014597
Min length2
ValueCountFrequency (%) 
Uppercase_Letter 24 92.3%
 
Lowercase_Letter 2 7.7%
 
ValueCountFrequency (%) 
Latin 26 100.0%
 
ValueCountFrequency (%) 
ASCII 26 100.0%
 

dti
Real number (ℝ)

SKEWED
Distinct count10845
Unique (%)0.5%
Missing1744
Missing (%)0.1%
Infinite0
Infinite (%)0.0%
Mean18.82419644
Minimum-1
Maximum999
Zeros1732
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum-1
5-th percentile4.94
Q111.89
median17.84
Q324.49
95-th percentile33.88
Maximum999
Range1000
Interquartile range (IQR)12.6

Descriptive statistics

Standard deviation14.18332854
Coefficient of variation (CV)0.7534626294
Kurtosis1755.261278
Mean18.82419644
Median Absolute Deviation (MAD)7.567932162
Skewness29.20185447
Sum42523050.31
Variance201.1668086
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1732 0.1%
 
18 1584 0.1%
 
14.4 1577 0.1%
 
16.8 1576 0.1%
 
19.2 1566 0.1%
 
15.6 1506 0.1%
 
13.2 1496 0.1%
 
12 1486 0.1%
 
20.4 1424 0.1%
 
21.6 1391 0.1%
 
Other values (10835) 2243619 99.2%
 
(Missing) 1744 0.1%
 
ValueCountFrequency (%) 
-1 2 < 0.1%
 
0 1732 0.1%
 
0.01 22 < 0.1%
 
0.02 35 < 0.1%
 
0.03 19 < 0.1%
 
ValueCountFrequency (%) 
999 135 < 0.1%
 
995.6 1 < 0.1%
 
995.17 1 < 0.1%
 
994.4 1 < 0.1%
 
991.57 1 < 0.1%
 

delinq_2yrs
Real number (ℝ≥0)

ZEROS
Distinct count37
Unique (%)< 0.1%
Missing62
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean0.3068791612
Minimum0
Maximum58
Zeros1839108
Zeros (%)81.4%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile2
Maximum58
Range58
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.8672303329
Coefficient of variation (CV)2.825966839
Kurtosis73.35208962
Mean0.3068791612
Median Absolute Deviation (MAD)0.4993136191
Skewness5.929811375
Sum693743
Variance0.7520884503
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1839108 81.4%
 
1 281353 12.4%
 
2 81289 3.6%
 
3 29542 1.3%
 
4 13179 0.6%
 
5 6599 0.3%
 
6 3717 0.2%
 
7 2062 0.1%
 
8 1223 0.1%
 
9 818 < 0.1%
 
Other values (27) 1749 0.1%
 
ValueCountFrequency (%) 
0 1839108 81.4%
 
1 281353 12.4%
 
2 81289 3.6%
 
3 29542 1.3%
 
4 13179 0.6%
 
ValueCountFrequency (%) 
58 1 < 0.1%
 
42 1 < 0.1%
 
39 1 < 0.1%
 
36 1 < 0.1%
 
35 1 < 0.1%
 

earliest_cr_line
Categorical

HIGH CARDINALITY
Distinct count754
Unique (%)< 0.1%
Missing62
Missing (%)< 0.1%
Memory size17.2 MiB
Sep-2004
 
15400
Sep-2003
 
15215
Sep-2005
 
14780
Aug-2003
 
14669
Aug-2004
 
14413
Other values (749)
2186162
ValueCountFrequency (%) 
Sep-2004 15400 0.7%
 
Sep-2003 15215 0.7%
 
Sep-2005 14780 0.7%
 
Aug-2003 14669 0.6%
 
Aug-2004 14413 0.6%
 
Aug-2001 14355 0.6%
 
Aug-2002 14322 0.6%
 
Aug-2005 14207 0.6%
 
Aug-2006 14143 0.6%
 
Oct-2003 14108 0.6%
 
Other values (744) 2115027 93.6%
 

Length

Max length8
Mean length7.999862874
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 14 42.4%
 
Decimal_Number 10 30.3%
 
Uppercase_Letter 8 24.2%
 
Dash_Punctuation 1 3.0%
 
ValueCountFrequency (%) 
Latin 22 66.7%
 
Common 11 33.3%
 
ValueCountFrequency (%) 
ASCII 33 100.0%
 

fico_range_low
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count48
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean698.5882049
Minimum610
Maximum845
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum610
5-th percentile660
Q1675
median690
Q3715
95-th percentile765
Maximum845
Range235
Interquartile range (IQR)40

Descriptive statistics

Standard deviation33.01037645
Coefficient of variation (CV)0.04725298283
Kurtosis1.315168369
Mean698.5882049
Median Absolute Deviation (MAD)25.83583873
Skewness1.192877206
Sum1579276000
Variance1089.684954
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
660 186580 8.3%
 
670 182119 8.1%
 
665 180759 8.0%
 
680 167199 7.4%
 
675 164016 7.3%
 
685 148009 6.5%
 
690 144690 6.4%
 
695 130941 5.8%
 
700 124184 5.5%
 
705 113074 5.0%
 
Other values (38) 719097 31.8%
 
ValueCountFrequency (%) 
610 2 < 0.1%
 
615 1 < 0.1%
 
620 1 < 0.1%
 
625 2 < 0.1%
 
630 6 < 0.1%
 
ValueCountFrequency (%) 
845 441 < 0.1%
 
840 572 < 0.1%
 
835 859 < 0.1%
 
830 1439 0.1%
 
825 2189 0.1%
 

fico_range_high
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count48
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean702.5884
Minimum614
Maximum850
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum614
5-th percentile664
Q1679
median694
Q3719
95-th percentile769
Maximum850
Range236
Interquartile range (IQR)40

Descriptive statistics

Standard deviation33.01124462
Coefficient of variation (CV)0.0469851831
Kurtosis1.316769731
Mean702.5884
Median Absolute Deviation (MAD)25.83606391
Skewness1.193116484
Sum1588319113
Variance1089.742271
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
664 186580 8.3%
 
674 182119 8.1%
 
669 180759 8.0%
 
684 167199 7.4%
 
679 164016 7.3%
 
689 148009 6.5%
 
694 144690 6.4%
 
699 130941 5.8%
 
704 124184 5.5%
 
709 113074 5.0%
 
Other values (38) 719097 31.8%
 
ValueCountFrequency (%) 
614 2 < 0.1%
 
619 1 < 0.1%
 
624 1 < 0.1%
 
629 2 < 0.1%
 
634 6 < 0.1%
 
ValueCountFrequency (%) 
850 441 < 0.1%
 
844 572 < 0.1%
 
839 859 < 0.1%
 
834 1439 0.1%
 
829 2189 0.1%
 

inq_last_6mths
Real number (ℝ≥0)

ZEROS
Distinct count28
Unique (%)< 0.1%
Missing63
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean0.5768353889
Minimum0
Maximum33
Zeros1381722
Zeros (%)61.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31
95-th percentile2
Maximum33
Range33
Interquartile range (IQR)1

Descriptive statistics

Standard deviation0.8859631583
Coefficient of variation (CV)1.53590292
Kurtosis9.57608952
Mean0.5768353889
Median Absolute Deviation (MAD)0.7051338138
Skewness2.066186683
Sum1304016
Variance0.784930718
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1381722 61.1%
 
1 584390 25.8%
 
2 200212 8.9%
 
3 69009 3.1%
 
4 17380 0.8%
 
5 6232 0.3%
 
6 1231 0.1%
 
7 195 < 0.1%
 
8 122 < 0.1%
 
9 50 < 0.1%
 
Other values (18) 95 < 0.1%
 
(Missing) 63 < 0.1%
 
ValueCountFrequency (%) 
0 1381722 61.1%
 
1 584390 25.8%
 
2 200212 8.9%
 
3 69009 3.1%
 
4 17380 0.8%
 
ValueCountFrequency (%) 
33 1 < 0.1%
 
32 1 < 0.1%
 
31 1 < 0.1%
 
28 1 < 0.1%
 
27 1 < 0.1%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Missing values

Sample

First rows

idmember_idloan_amntfunded_amntfunded_amnt_invtermint_rateinstallmentgradesub_gradeemp_titleemp_lengthhome_ownershipannual_incverification_statusissue_dloan_statuspymnt_planurldescpurposetitlezip_codeaddr_statedtidelinq_2yrsearliest_cr_linefico_range_lowfico_range_highinq_last_6mths
068407277NaN3600.03600.03600.036 months13.99123.03CC4leadman10+ yearsMORTGAGE55000.0Not VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=68407277NaNdebt_consolidationDebt consolidation190xxPA5.910.0Aug-2003675.0679.01.0
168355089NaN24700.024700.024700.036 months11.99820.28CC1Engineer10+ yearsMORTGAGE65000.0Not VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=68355089NaNsmall_businessBusiness577xxSD16.061.0Dec-1999715.0719.04.0
268341763NaN20000.020000.020000.060 months10.78432.66BB4truck driver10+ yearsMORTGAGE63000.0Not VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=68341763NaNhome_improvementNaN605xxIL10.780.0Aug-2000695.0699.00.0
366310712NaN35000.035000.035000.060 months14.85829.90CC5Information Systems Officer10+ yearsMORTGAGE110000.0Source VerifiedDec-2015Currentnhttps://lendingclub.com/browse/loanDetail.action?loan_id=66310712NaNdebt_consolidationDebt consolidation076xxNJ17.060.0Sep-2008785.0789.00.0
468476807NaN10400.010400.010400.060 months22.45289.91FF1Contract Specialist3 yearsMORTGAGE104433.0Source VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=68476807NaNmajor_purchaseMajor purchase174xxPA25.371.0Jun-1998695.0699.03.0
568426831NaN11950.011950.011950.036 months13.44405.18CC3Veterinary Tecnician4 yearsRENT34000.0Source VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=68426831NaNdebt_consolidationDebt consolidation300xxGA10.200.0Oct-1987690.0694.00.0
668476668NaN20000.020000.020000.036 months9.17637.58BB2Vice President of Recruiting Operations10+ yearsMORTGAGE180000.0Not VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=68476668NaNdebt_consolidationDebt consolidation550xxMN14.670.0Jun-1990680.0684.00.0
767275481NaN20000.020000.020000.036 months8.49631.26BB1road driver10+ yearsMORTGAGE85000.0Not VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=67275481NaNmajor_purchaseMajor purchase293xxSC17.611.0Feb-1999705.0709.00.0
868466926NaN10000.010000.010000.036 months6.49306.45AA2SERVICE MANAGER6 yearsRENT85000.0Not VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=68466926NaNcredit_cardCredit card refinancing160xxPA13.070.0Apr-2002685.0689.01.0
968616873NaN8000.08000.08000.036 months11.48263.74BB5Vendor liaison10+ yearsMORTGAGE42000.0Not VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=68616873NaNcredit_cardCredit card refinancing029xxRI34.800.0Nov-1994700.0704.00.0

Last rows

idmember_idloan_amntfunded_amntfunded_amnt_invtermint_rateinstallmentgradesub_gradeemp_titleemp_lengthhome_ownershipannual_incverification_statusissue_dloan_statuspymnt_planurldescpurposetitlezip_codeaddr_statedtidelinq_2yrsearliest_cr_linefico_range_lowfico_range_highinq_last_6mths
226069189996426NaN32000.032000.032000.060 months14.49752.74CC4Sales Manager3 yearsMORTGAGE157000.0Source VerifiedOct-2016Charged Offnhttps://lendingclub.com/browse/loanDetail.action?loan_id=89996426NaNhome_improvementHome improvement863xxAZ10.340.0Jun-2011735.0739.00.0
226069290006534NaN16000.016000.016000.060 months12.79362.34CC1Manager10+ yearsRENT150000.0Not VerifiedOct-2016Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=90006534NaNmedicalMedical expenses284xxNC12.250.0Aug-1997665.0669.00.0
226069389955820NaN24000.024000.024000.060 months10.49515.74BB3Current Operations Officer4 yearsOWN125000.0Not VerifiedOct-2016Currentnhttps://lendingclub.com/browse/loanDetail.action?loan_id=89955820NaNcredit_cardCredit card refinancing967xxHI10.980.0Feb-2001725.0729.00.0
226069489885898NaN24000.024000.024000.060 months12.79543.50CC1Unit Operator7 yearsMORTGAGE95000.0Source VerifiedOct-2016Currentnhttps://lendingclub.com/browse/loanDetail.action?loan_id=89885898NaNhome_improvementHome improvement356xxAL19.610.0Dec-1999665.0669.00.0
226069588977788NaN24000.024000.024000.060 months10.49515.74BB3Database Administrator10+ yearsMORTGAGE108000.0Not VerifiedOct-2016Currentnhttps://lendingclub.com/browse/loanDetail.action?loan_id=88977788NaNdebt_consolidationDebt consolidation840xxUT34.940.0Feb-1991695.0699.01.0
226069688985880NaN40000.040000.040000.060 months10.49859.56BB3Vice President9 yearsMORTGAGE227000.0VerifiedOct-2016Currentnhttps://lendingclub.com/browse/loanDetail.action?loan_id=88985880NaNdebt_consolidationNaN907xxCA12.757.0Feb-1995705.0709.01.0
226069788224441NaN24000.024000.024000.060 months14.49564.56CC4Program Manager6 yearsRENT110000.0Not VerifiedOct-2016Charged Offnhttps://lendingclub.com/browse/loanDetail.action?loan_id=88224441NaNdebt_consolidationDebt consolidation334xxFL18.300.0Jul-1999660.0664.00.0
226069888215728NaN14000.014000.014000.060 months14.49329.33CC4Customer Service Technician10+ yearsMORTGAGE95000.0VerifiedOct-2016Currentnhttps://lendingclub.com/browse/loanDetail.action?loan_id=88215728NaNdebt_consolidationNaN770xxTX23.360.0Jun-1996660.0664.01.0
2260699Total amount funded in policy code 1: 1465324575NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2260700Total amount funded in policy code 2: 521953170NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN